﻿CREATE TABLE [dbo].[Product]
(
	[ProductId] int identity NOT NULL, 
	[DiscountPercent] decimal(3,2) NOT NULL default 0,
	[HandlingCharge] money NOT NULL default 0,
	[LongDescription] nvarchar(max) NULL,
	[Name] nvarchar(100) NOT NULL,
	[Price] money NOT NULL default 0,
	[QuantityAvailable] int NOT NULL default 0,
	[SEOKeywords] nvarchar(1000) NULL,
	[SEOName] nvarchar(100) NOT NULL,
	[SEOTitle] nvarchar(100) NULL,
	[ShortDescription] nvarchar(1000) NULL,
	[Weight] decimal(9,2) NOT NULL default 0
);
